[Oracle SQL Tricks] Generating Dates Between Two Dates

1. Goal

用一段SQL產生指定日期區間內的所有日期

2. Code

SELECT backup_date
FROM ( SELECT trunc(to_date('20210201', 'yyyymmdd') - rownum - 1) as backup_date
       FROM dual
       CONNECT BY rownum <= 5
     )

3.Result

4. Description

• to_date(‘20210201’, ‘yyyymmdd’)：可換成任何日期
• rownum <= 5：可調整產生幾筆日期資料

5. Reference

Generate a range of dates using SQL